Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_HIST_TEMPFILE

`DBA_HIST_TEMPFILE` displays a history of the tempfile information from the control file. This view contains snapshots of `V$TEMPFILE`.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`DBID` | `NUMBER` | `NOT NULL` | Database ID
`FILE#` | `NUMBER` | `NOT NULL` | File identification number
`CREATION_CHANGE#` | `NUMBER` | `NOT NULL` | Change number at which the tempfile was created
`FILENAME` | `VARCHAR2(513)` | `NOT NULL` | Name of the tempfile
`TS#` | `NUMBER` | `NOT NULL` | Tablespace number
`TSNAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the tablespace
`BLOCK_SIZE` | `NUMBER` |  | Block size of the tempfile